Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

251
Views
sqlMessage: "Columna desconocida 'c.creada' en 'lista de campos'"

Recibo este error que no estoy completamente seguro de cómo resolver.

 CommentModel.getCommentsForPost = (postId) => { let baseSQL = `SELECT u.username, c.comment, c.created, c.id FROM comments c JOIN users u on u.id=fk_authorid WHERE c.fk_postid=? ORDER BY c.created DESC`; return db.query(baseSQL, [postId]) .then(([results, fields]) => { return Promise.resolve(results); }).catch(err => Promise.reject(err)); };

Error:

 code: 'ER_BAD_FIELD_ERROR', errno: 1054, sql: 'SELECT u.username, c.comment, c.created, c.id\n' + ' FROM comments c\n' + ' JOIN users u\n' + ' on u.id=fk_authorid\n' + " WHERE c.fk_postid='''1'''\n" + ' ORDER BY c.created DESC', sqlState: '42S22', sqlMessage: "Unknown column 'c.created' in 'field list'" }

¡Cualquier ayuda sería apreciada!

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!